www.gusucode.com > WSTMall PHP网店系统 v1.6.0PHP源码程序 > WSTMall PHP网店系统 v1.6.0/wstmall_v1.6.0_160506/wstmall_v1.6.0_160506/Apps/Home/Model/AttributeCatsModel.class.php
<?php namespace Home\Model; /** * ============================================================================ * WSTMall开源商城 * 官网地址:http://www.wstmall.com * 联系QQ:707563272 * ============================================================================ * 商品类型服务类 */ class AttributeCatsModel extends BaseModel { /** * 新增 */ public function insert(){ $m = M('attribute_cats'); $rd = array('status'=>-1); $data = array(); $data['catName'] = I('catName'); $data["shopId"] = (int)session('WST_USER.shopId'); if($this->checkEmpty($data)){ $data['catFlag'] = 1; $data['createTime'] = date('Y-m-d H:i:s'); $rs = $m->add($data); if(false !== $rs){ $rd['status']= 1; } } return $rd; } /** * 修改 */ public function edit(){ $m = M('attribute_cats'); $rd = array('status'=>-1); $shopId = (int)session('WST_USER.shopId'); $data = array(); $data['catName'] = I('catName'); if($this->checkEmpty($data)){ $catId = (int)I('id',0); $rs = $m->where("shopId=".$shopId." and catId=".$catId)->save($data); if(false !== $rs){ $rd['status']= 1; } } return $rd; } /** * 获取指定对象 */ public function get($catId = 0){ $id = $catId>0?$catId:(int)I('id'); $m = M('attribute_cats'); $shopId = (int)session('WST_USER.shopId'); return $m->where("shopId=".$shopId." and catId=".$id)->find(); } /** * 分页列表 */ public function queryByPage(){ $m = M('attribute_cats'); $shopId = (int)session('WST_USER.shopId'); return $m->where('shopId='.$shopId.' and catFlag=1')->field('catId,catName')->order('catId asc')->select(); } /** * 分页列表 */ public function queryByList(){ $m = M('attribute_cats'); $shopId = (int)session('WST_USER.shopId'); return $m->where('shopId='.$shopId.' and catFlag=1')->field('catId,catName')->order('catId asc')->select(); } /** * 删除 */ public function del(){ $rd = array('status'=>-1); $id = (int)I('id'); if($id==0)return $rd; $m = M('attributes'); $shopId = (int)session('WST_USER.shopId'); //找出其下的属性 $sql = "select attrId from __PREFIX__attributes where shopId=".$shopId." and catId=".$id; $attrRs = $m->query($sql); if(count($attrRs)>0){ $ids = array(); foreach ($attrRs as $v){ $ids[] = $v['attrId']; } $data = array(); $data['attrFlag'] = -1; //作废属性 $m->where("shopId=".$shopId." and attrId in(".implode(',',$ids).")")->save($data); $m = M('goods_attributes'); //删除相关商品的属性 $m->where("shopId=".$shopId." and attrId in(".implode(',',$ids).")")->delete(); } //删除商品中的引用 $rs = $m->execute("update __PREFIX__goods set attrCatId=0 where shopId=".$shopId." and attrCatId=".$id); //删除属性 $m = M('attribute_cats'); $rs = $m->execute("update __PREFIX__attribute_cats set catFlag=-1 where shopId=".$shopId." and catId=".$id); if(false !== $rs){ $rd['status']= 1; } return $rd; } }; ?>